package com.ecoolex.cms.system.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class VRNaviPathExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public VRNaviPathExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public VRNaviPathExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public VRNaviPathExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        VRNaviPathExample example = new VRNaviPathExample();
        return example.createCriteria();
    }

    public VRNaviPathExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public VRNaviPathExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public VRNaviPathExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public VRNaviPathExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public VRNaviPathExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("vrnavipath.Id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("vrnavipath.Id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("vrnavipath.Id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Id = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("vrnavipath.Id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Id <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("vrnavipath.Id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Id > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("vrnavipath.Id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Id >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("vrnavipath.Id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Id < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("vrnavipath.Id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Id <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("vrnavipath.Id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("vrnavipath.Id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("vrnavipath.Id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("vrnavipath.Id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andSceneIdIsNull() {
            addCriterion("vrnavipath.SceneId is null");
            return (Criteria) this;
        }

        public Criteria andSceneIdIsNotNull() {
            addCriterion("vrnavipath.SceneId is not null");
            return (Criteria) this;
        }

        public Criteria andSceneIdEqualTo(Integer value) {
            addCriterion("vrnavipath.SceneId =", value, "sceneId");
            return (Criteria) this;
        }

        public Criteria andSceneIdEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.SceneId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSceneIdNotEqualTo(Integer value) {
            addCriterion("vrnavipath.SceneId <>", value, "sceneId");
            return (Criteria) this;
        }

        public Criteria andSceneIdNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.SceneId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSceneIdGreaterThan(Integer value) {
            addCriterion("vrnavipath.SceneId >", value, "sceneId");
            return (Criteria) this;
        }

        public Criteria andSceneIdGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.SceneId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSceneIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("vrnavipath.SceneId >=", value, "sceneId");
            return (Criteria) this;
        }

        public Criteria andSceneIdGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.SceneId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSceneIdLessThan(Integer value) {
            addCriterion("vrnavipath.SceneId <", value, "sceneId");
            return (Criteria) this;
        }

        public Criteria andSceneIdLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.SceneId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSceneIdLessThanOrEqualTo(Integer value) {
            addCriterion("vrnavipath.SceneId <=", value, "sceneId");
            return (Criteria) this;
        }

        public Criteria andSceneIdLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.SceneId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSceneIdIn(List<Integer> values) {
            addCriterion("vrnavipath.SceneId in", values, "sceneId");
            return (Criteria) this;
        }

        public Criteria andSceneIdNotIn(List<Integer> values) {
            addCriterion("vrnavipath.SceneId not in", values, "sceneId");
            return (Criteria) this;
        }

        public Criteria andSceneIdBetween(Integer value1, Integer value2) {
            addCriterion("vrnavipath.SceneId between", value1, value2, "sceneId");
            return (Criteria) this;
        }

        public Criteria andSceneIdNotBetween(Integer value1, Integer value2) {
            addCriterion("vrnavipath.SceneId not between", value1, value2, "sceneId");
            return (Criteria) this;
        }

        public Criteria andStartPanoIsNull() {
            addCriterion("vrnavipath.StartPano is null");
            return (Criteria) this;
        }

        public Criteria andStartPanoIsNotNull() {
            addCriterion("vrnavipath.StartPano is not null");
            return (Criteria) this;
        }

        public Criteria andStartPanoEqualTo(String value) {
            addCriterion("vrnavipath.StartPano =", value, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.StartPano = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartPanoNotEqualTo(String value) {
            addCriterion("vrnavipath.StartPano <>", value, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.StartPano <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartPanoGreaterThan(String value) {
            addCriterion("vrnavipath.StartPano >", value, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.StartPano > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartPanoGreaterThanOrEqualTo(String value) {
            addCriterion("vrnavipath.StartPano >=", value, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.StartPano >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartPanoLessThan(String value) {
            addCriterion("vrnavipath.StartPano <", value, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.StartPano < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartPanoLessThanOrEqualTo(String value) {
            addCriterion("vrnavipath.StartPano <=", value, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.StartPano <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartPanoLike(String value) {
            addCriterion("vrnavipath.StartPano like", value, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoNotLike(String value) {
            addCriterion("vrnavipath.StartPano not like", value, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoIn(List<String> values) {
            addCriterion("vrnavipath.StartPano in", values, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoNotIn(List<String> values) {
            addCriterion("vrnavipath.StartPano not in", values, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoBetween(String value1, String value2) {
            addCriterion("vrnavipath.StartPano between", value1, value2, "startPano");
            return (Criteria) this;
        }

        public Criteria andStartPanoNotBetween(String value1, String value2) {
            addCriterion("vrnavipath.StartPano not between", value1, value2, "startPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoIsNull() {
            addCriterion("vrnavipath.EndPano is null");
            return (Criteria) this;
        }

        public Criteria andEndPanoIsNotNull() {
            addCriterion("vrnavipath.EndPano is not null");
            return (Criteria) this;
        }

        public Criteria andEndPanoEqualTo(String value) {
            addCriterion("vrnavipath.EndPano =", value, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.EndPano = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndPanoNotEqualTo(String value) {
            addCriterion("vrnavipath.EndPano <>", value, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.EndPano <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndPanoGreaterThan(String value) {
            addCriterion("vrnavipath.EndPano >", value, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.EndPano > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndPanoGreaterThanOrEqualTo(String value) {
            addCriterion("vrnavipath.EndPano >=", value, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.EndPano >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndPanoLessThan(String value) {
            addCriterion("vrnavipath.EndPano <", value, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.EndPano < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndPanoLessThanOrEqualTo(String value) {
            addCriterion("vrnavipath.EndPano <=", value, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.EndPano <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndPanoLike(String value) {
            addCriterion("vrnavipath.EndPano like", value, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoNotLike(String value) {
            addCriterion("vrnavipath.EndPano not like", value, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoIn(List<String> values) {
            addCriterion("vrnavipath.EndPano in", values, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoNotIn(List<String> values) {
            addCriterion("vrnavipath.EndPano not in", values, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoBetween(String value1, String value2) {
            addCriterion("vrnavipath.EndPano between", value1, value2, "endPano");
            return (Criteria) this;
        }

        public Criteria andEndPanoNotBetween(String value1, String value2) {
            addCriterion("vrnavipath.EndPano not between", value1, value2, "endPano");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewIsNull() {
            addCriterion("vrnavipath.PorwardNaviview is null");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewIsNotNull() {
            addCriterion("vrnavipath.PorwardNaviview is not null");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewEqualTo(String value) {
            addCriterion("vrnavipath.PorwardNaviview =", value, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.PorwardNaviview = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewNotEqualTo(String value) {
            addCriterion("vrnavipath.PorwardNaviview <>", value, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.PorwardNaviview <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewGreaterThan(String value) {
            addCriterion("vrnavipath.PorwardNaviview >", value, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.PorwardNaviview > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewGreaterThanOrEqualTo(String value) {
            addCriterion("vrnavipath.PorwardNaviview >=", value, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.PorwardNaviview >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewLessThan(String value) {
            addCriterion("vrnavipath.PorwardNaviview <", value, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.PorwardNaviview < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewLessThanOrEqualTo(String value) {
            addCriterion("vrnavipath.PorwardNaviview <=", value, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.PorwardNaviview <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewLike(String value) {
            addCriterion("vrnavipath.PorwardNaviview like", value, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewNotLike(String value) {
            addCriterion("vrnavipath.PorwardNaviview not like", value, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewIn(List<String> values) {
            addCriterion("vrnavipath.PorwardNaviview in", values, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewNotIn(List<String> values) {
            addCriterion("vrnavipath.PorwardNaviview not in", values, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewBetween(String value1, String value2) {
            addCriterion("vrnavipath.PorwardNaviview between", value1, value2, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andPorwardNaviviewNotBetween(String value1, String value2) {
            addCriterion("vrnavipath.PorwardNaviview not between", value1, value2, "porwardNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewIsNull() {
            addCriterion("vrnavipath.RetreatNaviview is null");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewIsNotNull() {
            addCriterion("vrnavipath.RetreatNaviview is not null");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewEqualTo(String value) {
            addCriterion("vrnavipath.RetreatNaviview =", value, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.RetreatNaviview = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewNotEqualTo(String value) {
            addCriterion("vrnavipath.RetreatNaviview <>", value, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.RetreatNaviview <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewGreaterThan(String value) {
            addCriterion("vrnavipath.RetreatNaviview >", value, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.RetreatNaviview > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewGreaterThanOrEqualTo(String value) {
            addCriterion("vrnavipath.RetreatNaviview >=", value, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.RetreatNaviview >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewLessThan(String value) {
            addCriterion("vrnavipath.RetreatNaviview <", value, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.RetreatNaviview < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewLessThanOrEqualTo(String value) {
            addCriterion("vrnavipath.RetreatNaviview <=", value, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.RetreatNaviview <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewLike(String value) {
            addCriterion("vrnavipath.RetreatNaviview like", value, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewNotLike(String value) {
            addCriterion("vrnavipath.RetreatNaviview not like", value, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewIn(List<String> values) {
            addCriterion("vrnavipath.RetreatNaviview in", values, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewNotIn(List<String> values) {
            addCriterion("vrnavipath.RetreatNaviview not in", values, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewBetween(String value1, String value2) {
            addCriterion("vrnavipath.RetreatNaviview between", value1, value2, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andRetreatNaviviewNotBetween(String value1, String value2) {
            addCriterion("vrnavipath.RetreatNaviview not between", value1, value2, "retreatNaviview");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("vrnavipath.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("vrnavipath.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("vrnavipath.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("vrnavipath.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("vrnavipath.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("vrnavipath.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("vrnavipath.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("vrnavipath.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("vrnavipath.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("vrnavipath.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("vrnavipath.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("vrnavipath.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("vrnavipath.CreateUser is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("vrnavipath.CreateUser is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("vrnavipath.CreateUser =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("vrnavipath.CreateUser <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("vrnavipath.CreateUser >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("vrnavipath.CreateUser >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("vrnavipath.CreateUser <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("vrnavipath.CreateUser <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("vrnavipath.CreateUser like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("vrnavipath.CreateUser not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("vrnavipath.CreateUser in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("vrnavipath.CreateUser not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("vrnavipath.CreateUser between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("vrnavipath.CreateUser not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("vrnavipath.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("vrnavipath.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("vrnavipath.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("vrnavipath.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("vrnavipath.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("vrnavipath.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("vrnavipath.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("vrnavipath.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("vrnavipath.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("vrnavipath.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("vrnavipath.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("vrnavipath.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("vrnavipath.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("vrnavipath.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("vrnavipath.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("vrnavipath.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("vrnavipath.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("vrnavipath.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("vrnavipath.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("vrnavipath.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("vrnavipath.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("vrnavipath.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("vrnavipath.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("vrnavipath.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("vrnavipath.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("vrnavipath.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("vrnavipath.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("vrnavipath.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("vrnavipath.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("vrnavipath.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("vrnavipath.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("vrnavipath.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("vrnavipath.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("vrnavipath.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(VRNaviPath.Column column) {
            addCriterion(new StringBuilder("vrnavipath.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("vrnavipath.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("vrnavipath.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("vrnavipath.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("vrnavipath.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private VRNaviPathExample example;

        protected Criteria(VRNaviPathExample example) {
            super();
            this.example = example;
        }

        public VRNaviPathExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(VRNaviPath.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(VRNaviPath.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.cms.system.entity.VRNaviPathExample example);
    }
}